How to: Sort data on two or more fields.
Solution:
In the Datasheet view, use the 'Advanced Filter/Sort...' command on the 'Filter' submenu of the 'Records' menu.
1) If the Database window is not active, activate the Database window.
2) Open the table in the Table Datasheet view.
3) Select the 'Records' menu and select 'Filter'. (A submenu appears.)
4) Select 'Advanced Filter/Sort...' from the submenu. (The advanced sort window appears.)
5) Do the following in the first column in the bottom section of the window:
a) Click in the 'Field' row. (A down arrow appears.)
Down arrow
b) Click on the arrow. (A drop-down list appears.)
c) Select the first field on which to sort from the 'Field' drop-down list.
Field drop-down list
d) Click in the 'Sort' row. (A down arrow appears.)
Down arrow
e) Click on the arrow. (A drop-down list appears.)
f) Select 'Ascending', 'Descending', or '(not sorted)' from the 'Sort' drop-down list.
Sort drop-down list
g) (Optional) Type any criteria in the 'Criteria' and 'or' rows.
6) Repeat step 5) in the next column for the next field on which to sort.
7) Repeat step 6) until all desired fields on which to sort have been selected.
8) Do one of the following:
a) To apply the sort, select the 'Filter' menu and select 'Apply Filter/Sort'.
b) To close the advanced sort window WITHOUT applying the sort, select the 'File' menu and select 'Close'.